﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Browse_SeriesByAgency : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        using (PublicCatalogDataContext db = new PublicCatalogDataContext())
        {
            
            
var myProvSeries = from a in db.Provenances
                   join b in db.Series on a.ProvenanceId equals b.ProvenanceId
                   join c in db.ProvenanceVariants on a.ProvenanceId equals c.ProvenanceId
                   join d in db.Qualifiers on c.QualifierId equals d.QualifierId
                   select new
                                {
                                    a.ProvenanceName,
                                    b.SeriesTitle,
                                    b.SeriesId,
                                    c.ProvenanceVariantName
                                };
            Repeater1.DataSource = myProvSeries;
            Repeater1.DataBind();
        }
    }
}
